/*查询用户组*/
'use strict';

const conn = require('../../libs/DB/Conn');

module.exports = async function (params) {
    let querySql = `SELECT
					   ug.group_id AS groupId,
                       ug.group_name AS groupName
                    FROM
                        user_group ug
                    WHERE
                       ug.domain_id = ${params.userDomainId}
                       AND ug.delete_sign = 1 
                       AND ug.is_manager = 0
                    ORDER BY group_id ASC`;
    let result = await conn(querySql);

    return {success:true,data:result}
};
